﻿if exists(SELECT * FROM sys.objects o WHERE o.[object_id]= OBJECT_ID('V_FullAndFree') AND o.[type]=N'V')
BEGIN
	DROP VIEW V_FullAndFree
END
GO
	Create view V_FullAndFree
	as
	Select 
		[SalesPromotionInfoGuid]
      ,[MinimalCost]
      ,[FreeItem]
     
  FROM [ShopNum1_FullAndFree]
